Elements and Performance Criteria
- Start up a database
- Manage the database
- Take action to ensure that a data dictionary has been compiled and that data structures are in place
- Maintain data integrity constraints, according to business requirements
- Create and design indexes, and multiple-field keys, according to business requirements
- Monitor the locking options chosen for the database
- Confirm that recent backups of the database have been stored, and that backups can be retrieved as a full working copy
- Monitor data storage space for ongoing viability, and resize as needed
- Update the data according to organisational guidelines
- Manage database access
- Document database maintenance tasks